MySQL Console allows you to use a command-line interface. In other words, it provides interactive text-based screen for you to query input and result output from database.
Open Console
To open Console
- Open the connection and select Tools -> Console from the main menu or just simply press Cmd-Shift-C.
- Edit your SQL statement in the console command prompt.
Hint: To open a new console window you can also control-click the Connection/Database node of the navigation pane and select Console from the popup menu.
Hint: You are allowed to open multiple console windows which represents different connection each.
Exit Console
To exit Console
- Click the cross button at the main bar.